Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	2899
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	328.5 KiB
Average record size in memory	116.0 B

Variable types

Numeric	13
Categorical	2

Warnings

`日期` has a high cardinality: 2899 distinct values	High cardinality
`df_index` is highly correlated with `总市值` and 1 other fields	High correlation
`收盘价` is highly correlated with `最高价` and 7 other fields	High correlation
`最高价` is highly correlated with `收盘价` and 7 other fields	High correlation
`最低价` is highly correlated with `收盘价` and 6 other fields	High correlation
`开盘价` is highly correlated with `收盘价` and 7 other fields	High correlation
`前收盘` is highly correlated with `收盘价` and 7 other fields	High correlation
`换手率` is highly correlated with `成交量` and 1 other fields	High correlation
`成交量` is highly correlated with `收盘价` and 7 other fields	High correlation
`成交金额` is highly correlated with `收盘价` and 8 other fields	High correlation
`总市值` is highly correlated with `df_index` and 8 other fields	High correlation
`流通市值` is highly correlated with `df_index` and 8 other fields	High correlation
`涨跌额` is highly correlated with `涨跌幅`	High correlation
`涨跌幅` is highly correlated with `涨跌额`	High correlation
`df_index` is highly correlated with `总市值` and 1 other fields	High correlation
`收盘价` is highly correlated with `最高价` and 6 other fields	High correlation
`最高价` is highly correlated with `收盘价` and 6 other fields	High correlation
`最低价` is highly correlated with `收盘价` and 6 other fields	High correlation
`开盘价` is highly correlated with `收盘价` and 6 other fields	High correlation
`前收盘` is highly correlated with `收盘价` and 6 other fields	High correlation
`换手率` is highly correlated with `成交量` and 1 other fields	High correlation
`成交量` is highly correlated with `换手率` and 3 other fields	High correlation
`成交金额` is highly correlated with `收盘价` and 8 other fields	High correlation
`总市值` is highly correlated with `df_index` and 8 other fields	High correlation
`流通市值` is highly correlated with `df_index` and 8 other fields	High correlation
`涨跌额` is highly correlated with `涨跌幅`	High correlation
`涨跌幅` is highly correlated with `涨跌额`	High correlation
`df_index` is highly correlated with `流通市值`	High correlation
`收盘价` is highly correlated with `最高价` and 7 other fields	High correlation
`最高价` is highly correlated with `收盘价` and 7 other fields	High correlation
`最低价` is highly correlated with `收盘价` and 7 other fields	High correlation
`开盘价` is highly correlated with `收盘价` and 7 other fields	High correlation
`前收盘` is highly correlated with `收盘价` and 7 other fields	High correlation
`换手率` is highly correlated with `成交量` and 1 other fields	High correlation
`成交量` is highly correlated with `换手率` and 2 other fields	High correlation
`成交金额` is highly correlated with `收盘价` and 8 other fields	High correlation
`总市值` is highly correlated with `收盘价` and 7 other fields	High correlation
`流通市值` is highly correlated with `df_index` and 8 other fields	High correlation
`涨跌额` is highly correlated with `涨跌幅` and 1 other fields	High correlation
`涨跌幅` is highly correlated with `涨跌额` and 1 other fields	High correlation
`次日涨跌` is highly correlated with `收盘价` and 11 other fields	High correlation
`总市值` is highly correlated with `开盘价` and 9 other fields	High correlation
`开盘价` is highly correlated with `总市值` and 9 other fields	High correlation
`涨跌幅` is highly correlated with `涨跌额`	High correlation
`成交量` is highly correlated with `总市值` and 10 other fields	High correlation
`最高价` is highly correlated with `总市值` and 9 other fields	High correlation
`成交金额` is highly correlated with `总市值` and 10 other fields	High correlation
`最低价` is highly correlated with `总市值` and 9 other fields	High correlation
`流通市值` is highly correlated with `总市值` and 9 other fields	High correlation
`收盘价` is highly correlated with `总市值` and 9 other fields	High correlation
`df_index` is highly correlated with `总市值` and 8 other fields	High correlation
`换手率` is highly correlated with `成交量` and 1 other fields	High correlation
`涨跌额` is highly correlated with `总市值` and 9 other fields	High correlation
`前收盘` is highly correlated with `总市值` and 9 other fields	High correlation
`日期` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`日期` has unique values	Unique
`成交量` has unique values	Unique
`成交金额` has unique values	Unique
`涨跌额` has 69 (2.4%) zeros	Zeros
`涨跌幅` has 69 (2.4%) zeros	Zeros

Reproduction

Analysis started	2021-08-06 05:24:44.231063
Analysis finished	2021-08-06 05:24:59.825685
Duration	15.59 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	2899
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1590.219041

Minimum	0
Maximum	3212
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	0
5-th percentile	144.9
Q1	728.5
median	1568
Q3	2475.5
95-th percentile	3063.1
Maximum	3212
Range	3212
Interquartile range (IQR)	1747

Descriptive statistics

Standard deviation	967.1750962
Coefficient of variation (CV)	0.608202437
Kurtosis	-1.330087003
Mean	1590.219041
Median Absolute Deviation (MAD)	874
Skewness	0.03818590785
Sum	4610045
Variance	935427.6666
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
2224	1	< 0.1%
2226	1	< 0.1%
2227	1	< 0.1%
2228	1	< 0.1%
2229	1	< 0.1%
2230	1	< 0.1%
2231	1	< 0.1%
2232	1	< 0.1%
2233	1	< 0.1%
Other values (2889)	2889	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
3212	1	< 0.1%
3211	1	< 0.1%
3210	1	< 0.1%
3209	1	< 0.1%
3208	1	< 0.1%
3207	1	< 0.1%
3206	1	< 0.1%
3205	1	< 0.1%
3204	1	< 0.1%
3203	1	< 0.1%

日期
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	2899
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	22.8 KiB

2021/8/5	1
2012/6/15	1
2012/6/13	1
2012/6/12	1
2012/6/11	1
Other values (2894)	2894

Length

Max length	10
Median length	9
Mean length	8.962400828
Min length	8

Characters and Unicode

Total characters	25982
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2899 ?
Unique (%)	100.0%

Sample

1st row	2021/8/5
2nd row	2021/8/4
3rd row	2021/8/3
4th row	2021/8/2
5th row	2021/7/30

Common Values

Value	Count	Frequency (%)
2021/8/5	1	< 0.1%
2012/6/15	1	< 0.1%
2012/6/13	1	< 0.1%
2012/6/12	1	< 0.1%
2012/6/11	1	< 0.1%
2012/6/8	1	< 0.1%
2012/6/7	1	< 0.1%
2012/6/6	1	< 0.1%
2012/6/5	1	< 0.1%
2012/6/4	1	< 0.1%
Other values (2889)	2889	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021/8/5	1	< 0.1%
2012/6/15	1	< 0.1%
2012/6/13	1	< 0.1%
2012/6/12	1	< 0.1%
2012/6/11	1	< 0.1%
2012/6/8	1	< 0.1%
2012/6/7	1	< 0.1%
2012/6/6	1	< 0.1%
2012/6/5	1	< 0.1%
2012/6/4	1	< 0.1%
Other values (2889)	2889	99.7%

Most occurring characters

Value	Count	Frequency (%)
/	5798	22.3%
2	5269	20.3%
1	4970	19.1%
0	4241	16.3%
9	988	3.8%
8	928	3.6%
7	804	3.1%
3	787	3.0%
6	772	3.0%
4	768	3.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	20184	77.7%
Other Punctuation	5798	22.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	5269	26.1%
1	4970	24.6%
0	4241	21.0%
9	988	4.9%
8	928	4.6%
7	804	4.0%
3	787	3.9%
6	772	3.8%
4	768	3.8%
5	657	3.3%

Other Punctuation

Value	Count	Frequency (%)
/	5798	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25982	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
/	5798	22.3%
2	5269	20.3%
1	4970	19.1%
0	4241	16.3%
9	988	3.8%
8	928	3.6%
7	804	3.1%
3	787	3.0%
6	772	3.0%
4	768	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25982	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	5798	22.3%
2	5269	20.3%
1	4970	19.1%
0	4241	16.3%
9	988	3.8%
8	928	3.6%
7	804	3.1%
3	787	3.0%
6	772	3.0%
4	768	3.0%

收盘价
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1433
Distinct (%)	49.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.25770956

Minimum	3.57
Maximum	51.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	3.57
5-th percentile	4.159
Q1	8.09
median	10.77
Q3	14.67
95-th percentile	25.635
Maximum	51.2
Range	47.63
Interquartile range (IQR)	6.58

Descriptive statistics

Standard deviation	6.650284717
Coefficient of variation (CV)	0.5425389374
Kurtosis	4.052231069
Mean	12.25770956
Median Absolute Deviation (MAD)	3
Skewness	1.619935896
Sum	35535.1
Variance	44.22628682
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.4	13	0.4%
8	9	0.3%
8.97	9	0.3%
8.6	8	0.3%
8.41	8	0.3%
11.14	8	0.3%
4.04	8	0.3%
11.2	7	0.2%
12.07	7	0.2%
8.82	7	0.2%
Other values (1423)	2815	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.57	1	< 0.1%
3.59	3	0.1%
3.6	1	< 0.1%
3.68	1	< 0.1%
3.7	2	0.1%
3.74	1	< 0.1%
3.75	1	< 0.1%
3.77	2	0.1%
3.78	1	< 0.1%
3.79	3	0.1%

Value	Count	Frequency (%)
51.2	1	< 0.1%
49.53	1	< 0.1%
49.5	1	< 0.1%
49.4	1	< 0.1%
48.3	1	< 0.1%
48.08	1	< 0.1%
46.65	1	< 0.1%
46.6	1	< 0.1%
46.56	1	< 0.1%
46.15	1	< 0.1%

最高价
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1435
Distinct (%)	49.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.5584098

Minimum	3.61
Maximum	53.13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	3.61
5-th percentile	4.22
Q1	8.28
median	10.95
Q3	14.99
95-th percentile	26.131
Maximum	53.13
Range	49.52
Interquartile range (IQR)	6.71

Descriptive statistics

Standard deviation	6.879166209
Coefficient of variation (CV)	0.5477736688
Kurtosis	4.44559435
Mean	12.5584098
Median Absolute Deviation (MAD)	3.06
Skewness	1.674542528
Sum	36406.83
Variance	47.32292773
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.55	13	0.4%
4.09	12	0.4%
12.09	10	0.3%
9.33	9	0.3%
8.55	8	0.3%
4.08	8	0.3%
9.78	8	0.3%
11.15	8	0.3%
12.2	8	0.3%
4.19	7	0.2%
Other values (1425)	2808	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.61	1	< 0.1%
3.62	1	< 0.1%
3.66	1	< 0.1%
3.69	1	< 0.1%
3.73	1	< 0.1%
3.74	1	< 0.1%
3.77	2	0.1%
3.82	2	0.1%
3.83	1	< 0.1%
3.84	1	< 0.1%

Value	Count	Frequency (%)
53.13	1	< 0.1%
52.98	1	< 0.1%
52.7	1	< 0.1%
51.89	1	< 0.1%
50.66	1	< 0.1%
49.98	1	< 0.1%
49.73	1	< 0.1%
49.5	1	< 0.1%
48.88	1	< 0.1%
48.86	1	< 0.1%

最低价
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1375
Distinct (%)	47.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.94749569

Minimum	3.48
Maximum	49.84
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	3.48
5-th percentile	4.08
Q1	7.9
median	10.52
Q3	14.33
95-th percentile	24.81
Maximum	49.84
Range	46.36
Interquartile range (IQR)	6.43

Descriptive statistics

Standard deviation	6.407963252
Coefficient of variation (CV)	0.5363436338
Kurtosis	3.722209969
Mean	11.94749569
Median Absolute Deviation (MAD)	2.92
Skewness	1.566630021
Sum	34635.79
Variance	41.06199304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.8	11	0.4%
11.38	10	0.3%
8.81	9	0.3%
8.9	9	0.3%
7	8	0.3%
11.5	8	0.3%
3.86	8	0.3%
7.88	8	0.3%
8.2	8	0.3%
7.8	8	0.3%
Other values (1365)	2812	97.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.48	2	0.1%
3.5	1	< 0.1%
3.54	1	< 0.1%
3.55	1	< 0.1%
3.56	1	< 0.1%
3.61	1	< 0.1%
3.64	2	0.1%
3.67	1	< 0.1%
3.7	1	< 0.1%
3.71	3	0.1%

Value	Count	Frequency (%)
49.84	1	< 0.1%
47.92	1	< 0.1%
47.3	1	< 0.1%
46.61	1	< 0.1%
45.72	1	< 0.1%
45.7	1	< 0.1%
45	1	< 0.1%
44.29	1	< 0.1%
43.47	1	< 0.1%
43.28	1	< 0.1%

开盘价
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1394
Distinct (%)	48.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.22971369

Minimum	3.53
Maximum	50.25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	3.53
5-th percentile	4.16
Q1	8.05
median	10.7
Q3	14.665
95-th percentile	25.482
Maximum	50.25
Range	46.72
Interquartile range (IQR)	6.615

Descriptive statistics

Standard deviation	6.616875003
Coefficient of variation (CV)	0.5410490522
Kurtosis	4.019029525
Mean	12.22971369
Median Absolute Deviation (MAD)	3
Skewness	1.610315584
Sum	35453.94
Variance	43.7830348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	14	0.5%
8.3	11	0.4%
11.2	10	0.3%
9.3	10	0.3%
4.03	10	0.3%
8.33	9	0.3%
9.1	9	0.3%
8	9	0.3%
10.7	8	0.3%
8.6	8	0.3%
Other values (1384)	2801	96.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.53	1	< 0.1%
3.54	1	< 0.1%
3.57	2	0.1%
3.6	1	< 0.1%
3.65	1	< 0.1%
3.67	1	< 0.1%
3.71	1	< 0.1%
3.73	1	< 0.1%
3.74	2	0.1%
3.76	3	0.1%

Value	Count	Frequency (%)
50.25	1	< 0.1%
50	1	< 0.1%
49.1	1	< 0.1%
49.01	1	< 0.1%
49	1	< 0.1%
48.5	1	< 0.1%
47.56	1	< 0.1%
45.92	1	< 0.1%
45.88	1	< 0.1%
45.54	1	< 0.1%

前收盘
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1435
Distinct (%)	49.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.2493791

Minimum	3.57
Maximum	51.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	3.57
5-th percentile	4.159
Q1	8.08
median	10.76
Q3	14.67
95-th percentile	25.567
Maximum	51.2
Range	47.63
Interquartile range (IQR)	6.59

Descriptive statistics

Standard deviation	6.62939826
Coefficient of variation (CV)	0.5412027995
Kurtosis	4.003919515
Mean	12.2493791
Median Absolute Deviation (MAD)	3
Skewness	1.607949074
Sum	35510.95
Variance	43.94892128
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.4	13	0.4%
8	10	0.3%
4.04	8	0.3%
8.97	8	0.3%
8.41	8	0.3%
11.14	8	0.3%
8.6	8	0.3%
8.79	7	0.2%
11.62	7	0.2%
10.03	7	0.2%
Other values (1425)	2815	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.57	1	< 0.1%
3.59	3	0.1%
3.6	1	< 0.1%
3.68	1	< 0.1%
3.7	2	0.1%
3.74	1	< 0.1%
3.75	1	< 0.1%
3.77	2	0.1%
3.78	1	< 0.1%
3.79	3	0.1%

Value	Count	Frequency (%)
51.2	1	< 0.1%
49.53	1	< 0.1%
49.5	1	< 0.1%
49.4	1	< 0.1%
48.3	1	< 0.1%
48.08	1	< 0.1%
46.65	1	< 0.1%
46.6	1	< 0.1%
46.56	1	< 0.1%
46.15	1	< 0.1%

换手率
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2841
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.43753377

Minimum	0.0564
Maximum	30.9481
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	0.0564
5-th percentile	0.52889
Q1	1.23805
median	2.483
Q3	4.6203
95-th percentile	9.48531
Maximum	30.9481
Range	30.8917
Interquartile range (IQR)	3.38225

Descriptive statistics

Standard deviation	3.088831522
Coefficient of variation (CV)	0.8985603426
Kurtosis	7.477158521
Mean	3.43753377
Median Absolute Deviation (MAD)	1.4839
Skewness	2.105149554
Sum	9965.4104
Variance	9.540880173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7255	3	0.1%
0.8872	3	0.1%
2.0426	2	0.1%
0.7471	2	0.1%
1.1542	2	0.1%
3.2102	2	0.1%
7.0536	2	0.1%
2.1273	2	0.1%
3.9113	2	0.1%
3.3984	2	0.1%
Other values (2831)	2877	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0564	1	< 0.1%
0.0695	1	< 0.1%
0.0964	1	< 0.1%
0.1398	1	< 0.1%
0.1998	1	< 0.1%
0.21	1	< 0.1%
0.2173	1	< 0.1%
0.2387	1	< 0.1%
0.2433	1	< 0.1%
0.2456	1	< 0.1%

Value	Count	Frequency (%)
30.9481	1	< 0.1%
29.0461	1	< 0.1%
22.0791	1	< 0.1%
21.0161	1	< 0.1%
19.7724	1	< 0.1%
19.6565	1	< 0.1%
19.4709	1	< 0.1%
19.1179	1	< 0.1%
18.9544	1	< 0.1%
18.8051	1	< 0.1%

成交量
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	2899
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13187923.01

Minimum	276620
Maximum	131994091
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	276620
5-th percentile	1962022
Q1	3828724
median	7413553
Q3	16305407.5
95-th percentile	45608388.7
Maximum	131994091
Range	131717471
Interquartile range (IQR)	12476683.5

Descriptive statistics

Standard deviation	14967638.22
Coefficient of variation (CV)	1.134950379
Kurtosis	7.087645043
Mean	13187923.01
Median Absolute Deviation (MAD)	4344032
Skewness	2.392091872
Sum	3.82317888 × 10¹⁰
Variance	2.240301937 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50074714	1	< 0.1%
10762105	1	< 0.1%
7367235	1	< 0.1%
10103623	1	< 0.1%
8867254	1	< 0.1%
11103661	1	< 0.1%
7932003	1	< 0.1%
8273539	1	< 0.1%
13688068	1	< 0.1%
18691010	1	< 0.1%
Other values (2889)	2889	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
276620	1	< 0.1%
340811	1	< 0.1%
473017	1	< 0.1%
661137	1	< 0.1%
686200	1	< 0.1%
721663	1	< 0.1%
782990	1	< 0.1%
810130	1	< 0.1%
865694	1	< 0.1%
904005	1	< 0.1%

Value	Count	Frequency (%)
131994091	1	< 0.1%
116692229	1	< 0.1%
96752489	1	< 0.1%
93947328	1	< 0.1%
93880894	1	< 0.1%
93812431	1	< 0.1%
90225107	1	< 0.1%
85508337	1	< 0.1%
85242186	1	< 0.1%
85221480	1	< 0.1%

成交金额
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	2899
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	213068441.5

Minimum	1936340
Maximum	4423090987
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	1936340
5-th percentile	13366741.51
Q1	33041985.98
median	72939052.84
Q3	213765773.8
95-th percentile	882266175.3
Maximum	4423090987
Range	4421154647
Interquartile range (IQR)	180723787.8

Descriptive statistics

Standard deviation	388832994.4
Coefficient of variation (CV)	1.824920629
Kurtosis	28.51915276
Mean	213068441.5
Median Absolute Deviation (MAD)	52052901.54
Skewness	4.539537797
Sum	6.176854119 × 10¹¹
Variance	1.511910975 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2081006127	1	< 0.1%
55937295.78	1	< 0.1%
37656679.47	1	< 0.1%
52212000.5	1	< 0.1%
44514587.62	1	< 0.1%
56542552.68	1	< 0.1%
42038196.32	1	< 0.1%
43433314.36	1	< 0.1%
73674204.83	1	< 0.1%
102748748.5	1	< 0.1%
Other values (2889)	2889	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1936340	1	< 0.1%
2167557.96	1	< 0.1%
2483339.25	1	< 0.1%
4475824.69	1	< 0.1%
5180171.4	1	< 0.1%
5290602	1	< 0.1%
5652146.11	1	< 0.1%
5840594.47	1	< 0.1%
5895667.1	1	< 0.1%
5896539.67	1	< 0.1%

Value	Count	Frequency (%)
4423090987	1	< 0.1%
4250258573	1	< 0.1%
4021694052	1	< 0.1%
3779452490	1	< 0.1%
3330406444	1	< 0.1%
3320109858	1	< 0.1%
3299274070	1	< 0.1%
3284071393	1	< 0.1%
3036815790	1	< 0.1%
2768295458	1	< 0.1%

总市值
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1988
Distinct (%)	68.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6302179588

Minimum	1542650700
Maximum	3.838510377 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	1542650700
5-th percentile	1997165280
Q1	3038377830
median	4882504800
Q3	7967471800
95-th percentile	1.528656769 × 10¹⁰
Maximum	3.838510377 × 10¹⁰
Range	3.684245307 × 10¹⁰
Interquartile range (IQR)	4929093970

Descriptive statistics

Standard deviation	4839745736
Coefficient of variation (CV)	0.7679479248
Kurtosis	9.441379182
Mean	6302179588
Median Absolute Deviation (MAD)	2079358200
Skewness	2.508096678
Sum	1.827001862 × 10¹³
Variance	2.342313879 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1982444160	8	0.3%
3434928000	7	0.2%
5701980480	7	0.2%
4496885039	7	0.2%
5765772000	6	0.2%
2006979360	6	0.2%
1972630080	6	0.2%
2046235680	6	0.2%
1913745600	6	0.2%
1967723040	6	0.2%
Other values (1978)	2834	97.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1542650700	2	0.1%
1561052100	1	< 0.1%
1564119000	1	< 0.1%
1567185900	1	< 0.1%
1579453500	1	< 0.1%
1585587300	1	< 0.1%
1600921800	1	< 0.1%
1603988700	1	< 0.1%
1622390100	2	0.1%
1637724600	1	< 0.1%

Value	Count	Frequency (%)
3.838510377 × 10¹⁰	1	< 0.1%
3.83578539 × 10¹⁰	1	< 0.1%
3.713308964 × 10¹⁰	1	< 0.1%
3.711059837 × 10¹⁰	1	< 0.1%
3.708732562 × 10¹⁰	1	< 0.1%
3.703562746 × 10¹⁰	1	< 0.1%
3.662924399 × 10¹⁰	1	< 0.1%
3.62109475 × 10¹⁰	1	< 0.1%
3.604601151 × 10¹⁰	1	< 0.1%
3.497392756 × 10¹⁰	1	< 0.1%

流通市值
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1952
Distinct (%)	67.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5428240290

Minimum	385750700
Maximum	3.565454935 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.8 KiB

Quantile statistics

Minimum	385750700
5-th percentile	671175542
Q1	1837686480
median	4288752960
Q3	7149557280
95-th percentile	1.419914573 × 10¹⁰
Maximum	3.565454935 × 10¹⁰
Range	3.526879865 × 10¹⁰
Interquartile range (IQR)	5311870800

Descriptive statistics

Standard deviation	4834566529
Coefficient of variation (CV)	0.8906323728
Kurtosis	6.424589002
Mean	5428240290
Median Absolute Deviation (MAD)	2698860788
Skewness	2.034365903
Sum	1.57364686 × 10¹³
Variance	2.337303352 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4121913600	10	0.3%
3925632000	8	0.3%
1982444160	8	0.3%
5466442560	7	0.2%
5701980480	7	0.2%
2046235680	6	0.2%
5765772000	6	0.2%
1967723040	6	0.2%
2006979360	6	0.2%
1972630080	6	0.2%
Other values (1942)	2829	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
385750700	2	0.1%
390352100	1	< 0.1%
391119000	1	< 0.1%
391885900	1	< 0.1%
394953500	1	< 0.1%
396487300	1	< 0.1%
400321800	1	< 0.1%
401088700	1	< 0.1%
405690100	2	0.1%
409524600	1	< 0.1%

Value	Count	Frequency (%)
3.565454935 × 10¹⁰	1	< 0.1%
3.449159823 × 10¹⁰	1	< 0.1%
3.447070689 × 10¹⁰	1	< 0.1%
3.44010691 × 10¹⁰	1	< 0.1%
3.363505339 × 10¹⁰	1	< 0.1%
3.348185025 × 10¹⁰	1	< 0.1%
3.248602983 × 10¹⁰	1	< 0.1%
3.245121093 × 10¹⁰	1	< 0.1%
3.242335582 × 10¹⁰	1	< 0.1%
3.213784087 × 10¹⁰	1	< 0.1%

涨跌额
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	328
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.008330458779

Minimum	-4.44
Maximum	4.5
Zeros	69
Zeros (%)	2.4%
Negative	1340
Negative (%)	46.2%
Memory size	22.8 KiB

Quantile statistics

Minimum	-4.44
5-th percentile	-0.77
Q1	-0.16
median	0.01
Q3	0.18
95-th percentile	0.791
Maximum	4.5
Range	8.94
Interquartile range (IQR)	0.34

Descriptive statistics

Standard deviation	0.5451746795
Coefficient of variation (CV)	65.44353606
Kurtosis	11.81591228
Mean	0.008330458779
Median Absolute Deviation (MAD)	0.17
Skewness	0.005687864129
Sum	24.15
Variance	0.2972154311
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	69	2.4%
0.03	63	2.2%
0.04	62	2.1%
0.05	59	2.0%
-0.02	54	1.9%
-0.03	54	1.9%
0.06	52	1.8%
0.01	52	1.8%
0.08	51	1.8%
0.09	50	1.7%
Other values (318)	2333	80.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4.44	1	< 0.1%
-3.92	1	< 0.1%
-3.38	1	< 0.1%
-3.09	1	< 0.1%
-2.8	2	0.1%
-2.74	1	< 0.1%
-2.59	1	< 0.1%
-2.56	1	< 0.1%
-2.43	2	0.1%
-2.42	1	< 0.1%

Value	Count	Frequency (%)
4.5	1	< 0.1%
4.24	1	< 0.1%
3.86	1	< 0.1%
3.27	1	< 0.1%
3.03	1	< 0.1%
2.97	1	< 0.1%
2.93	1	< 0.1%
2.72	1	< 0.1%
2.54	1	< 0.1%
2.47	1	< 0.1%

涨跌幅
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2679
Distinct (%)	92.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.09199244567

Minimum	-10.035
Maximum	10.0952
Zeros	69
Zeros (%)	2.4%
Negative	1340
Negative (%)	46.2%
Memory size	22.8 KiB

Quantile statistics

Minimum	-10.035
5-th percentile	-5.84227
Q1	-1.56555
median	0.1374
Q3	1.7925
95-th percentile	6.00645
Maximum	10.0952
Range	20.1302
Interquartile range (IQR)	3.35805

Descriptive statistics

Standard deviation	3.44458752
Coefficient of variation (CV)	37.44424333
Kurtosis	1.535819714
Mean	0.09199244567
Median Absolute Deviation (MAD)	1.6759
Skewness	0.003536367847
Sum	266.6861
Variance	11.86518318
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	69	2.4%
10	12	0.4%
-10	5	0.2%
2.7778	4	0.1%
-1.6043	3	0.1%
0.6623	3	0.1%
-2.9412	3	0.1%
2.0513	3	0.1%
2.1898	3	0.1%
2.2222	3	0.1%
Other values (2669)	2791	96.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-10.035	1	< 0.1%
-10.0301	1	< 0.1%
-10.0295	2	0.1%
-10.0182	1	< 0.1%
-10.0181	1	< 0.1%
-10.0162	1	< 0.1%
-10.0146	1	< 0.1%
-10.0126	1	< 0.1%
-10.0124	1	< 0.1%
-10.011	1	< 0.1%

Value	Count	Frequency (%)
10.0952	1	< 0.1%
10.0686	1	< 0.1%
10.0629	2	0.1%
10.0606	1	< 0.1%
10.052	1	< 0.1%
10.0488	1	< 0.1%
10.0413	1	< 0.1%
10.0379	1	< 0.1%
10.0372	1	< 0.1%
10.0366	1	< 0.1%

次日涨跌
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	22.8 KiB

1	1492
0	1407

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2899
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	1492	51.5%
0	1407	48.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	1492	51.5%
0	1407	48.5%

Most occurring characters

Value	Count	Frequency (%)
1	1492	51.5%
0	1407	48.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2899	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1492	51.5%
0	1407	48.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	2899	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1492	51.5%
0	1407	48.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2899	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1492	51.5%
0	1407	48.5%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	日期	收盘价	最高价	最低价	开盘价	前收盘	换手率	成交量	成交金额	总市值	流通市值	涨跌额	涨跌幅	次日涨跌
0	0	2021/8/5	42.38	42.82	40.14	41.06	42.91	7.1907	50074714	2.081006e+09	36629243993	2.951250e+10	-0.53	-1.2351	0
1	1	2021/8/4	42.91	43.39	40.18	40.62	39.94	9.2611	64492318	2.693173e+09	37087325619	2.988158e+10	2.97	7.4362	0
2	2	2021/8/3	39.94	43.24	39.94	43.00	44.38	9.1361	63621551	2.616777e+09	34520339903	2.781333e+10	-4.44	-10.0045	1
3	3	2021/8/2	44.38	49.73	43.47	49.00	48.30	13.8937	96752489	4.423091e+09	38357853903	3.090525e+10	-3.92	-8.1159	0
4	4	2021/7/30	48.30	51.89	45.70	47.56	48.08	9.8992	68936086	3.320110e+09	36210947501	3.363505e+10	0.22	0.4576	0
5	5	2021/7/29	48.08	49.98	46.61	48.50	46.56	7.7063	53665277	2.607217e+09	36046011509	3.348185e+10	1.52	3.2646	1
6	6	2021/7/28	46.56	48.18	43.20	45.54	46.15	6.5286	45464036	2.112774e+09	34906453741	3.242336e+10	0.41	0.8884	1
7	7	2021/7/27	46.15	53.13	45.00	49.10	49.53	8.0903	56339044	2.768295e+09	34599073027	3.213784e+10	-3.38	-6.8241	1
8	8	2021/7/26	49.53	50.66	47.30	49.01	49.40	5.3599	37325427	1.834160e+09	37133089643	3.449160e+10	0.13	0.2632	0
9	9	2021/7/23	49.40	52.70	47.92	50.00	51.20	6.9568	48445782	2.429679e+09	37035627465	3.440107e+10	-1.80	-3.5156	1

Last rows

	df_index	日期	收盘价	最高价	最低价	开盘价	前收盘	换手率	成交量	成交金额	总市值	流通市值	涨跌额	涨跌幅	次日涨跌
2889	3203	2008/6/6	17.01	17.47	16.80	16.91	16.85	6.4910	3982331	6.844929e+07	5216796900	1.043598e+09	0.16	0.9496	0
2890	3204	2008/6/5	16.85	16.98	16.67	16.95	16.86	4.8886	2999259	5.039372e+07	5167726500	1.033781e+09	-0.01	-0.0593	1
2891	3205	2008/6/4	16.86	17.18	16.76	17.18	17.05	5.1373	3151864	5.317705e+07	5170793400	1.034395e+09	-0.19	-1.1144	0
2892	3206	2008/6/3	17.05	17.47	16.95	17.30	17.27	7.7419	4749805	8.162274e+07	5229064500	1.046052e+09	-0.22	-1.2739	0
2893	3207	2008/6/2	17.27	17.48	17.01	17.25	17.24	6.3211	3878104	6.687937e+07	5296536300	1.059549e+09	0.03	0.1740	0
2894	3208	2008/5/30	17.24	17.75	16.83	17.68	17.70	11.2793	6920084	1.187726e+08	5287335600	1.057708e+09	-0.46	-2.5989	1
2895	3209	2008/5/29	17.70	18.17	17.51	17.64	17.64	11.1834	6861255	1.224930e+08	5428413000	1.085930e+09	0.06	0.3401	0
2896	3210	2008/5/28	17.64	18.09	17.30	17.84	18.01	16.0819	9866543	1.742992e+08	5410011600	1.082249e+09	-0.37	-2.0544	1
2897	3211	2008/5/27	18.01	18.80	17.85	18.68	18.40	15.3917	9443111	1.725063e+08	5523486900	1.104950e+09	-0.39	-2.1196	0
2898	3212	2008/5/26	18.40	19.69	18.40	19.69	20.44	29.0461	17820370	3.315659e+08	5643096000	1.128877e+09	-2.04	-9.9804	0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows